Hi there

Every time i use advanced find and export my finds into excel everything is fine and well, but when i the want to update the info in the dynamics excel sheet then the dates gets replaced by lots of "#######" and my hours gets all messed up and incorrect. Anyone know how to fix this?

I have tried almost everything google has told me such as activating the 1904 date system.

Hi Chris,

Based on your description, the error ####-Sometimes referred to as Railroad tracks, this error can be caused by several conditions:
A number in a cell is too wide for the cell to display it.
The formula in the cell produces a result that is too wide for the cell.
There is a negative number in the cell that has been formatted for dates or times. Dates and times in Excel must be positive values.

You can try these methods to help you solve this error:
Widen the column containing the problem cell.
Change the format of the problem cell to something other than a date/time format.
Correct the negative number in a date/time formatted cell.

I tried to reproduce your issue, but I didn't get your result. I suggest you provide steps of export the worksheet. You said >>when i the want to update the info in the dynamics excel sheet <<, please tell me how did you update it and please take a screenshot.

Please provide screenshots to our email address:
ibsofc@microsoft.com
Please Note: Please add the URL of the case in the email subject or body.

I'm glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su